<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@page import="java.io.Reader"%>
<%@page import="com.ibatis.sqlmap.client.SqlMapClientBuilder"%>
<%@page import="java.io.IOException"%>
<%@page import="com.ibatis.sqlmap.client.SqlMapClient"%>
<%@page import="com.ibatis.common.resources.Resources"%>
<%@page import="java.util.*"%>
<%
SqlMapClient sqlMapClient = null;

Reader reader = Resources.getResourceAsReader("ibatis/demo/SqlMapConfig.xml");
sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
reader.close(); 

request.setCharacterEncoding("UTF-8");

HashMap<String, Object> hm = null;

List aaa = sqlMapClient.queryForList("selectAllAccounts");

for(int i=0;i<aaa.size();i++)
{
	hm = (HashMap) aaa.get(i);
%>
<p><%= hm.get("EMPNO") %></p>
<%	
}
%>

